package com.spbtce.mapper;

import com.spbtce.model.Song;
import org.apache.ibatis.annotations.Insert;
import org.springframework.stereotype.Repository;
/**
 * @author Administrator
 * @version 1.0
 */
@Repository
public interface SongMapper {

    //@Insert("insert into song(id, name, singer, note, last_update_time) values(#{id}, #{name}, #{singer}, #{note}, #{lastUpdateTime})")
    void insert(Song song);

    //@Delete("delete from song where id = #{id}")
    void deleteById(String id);

    // @Update("update song set name = #{name}, singer = #{singer}, note = #{note}, last_update_time = #{lastUpdateTime} where id = #{id}")
    void updateById(Song song);

    // @Select("select * from song where id = #{id})
    Song selectById(String id);

}
